Release 10.1A: OpenEdge Data Management:
SQL Development

Verifying privileges

Privileges granted to users are specified in the following database system tables:

SYSPROGRESS.SYSCOLAUTH — This system table identifies users and the columns for which they have privileges. It also identifies the privileges the user has been granted, and the person who granted those privileges.
SYSPROGRESS.SYSDBAUTH — This system table identifies users who have authority to connect to a database, create tables, and perform administrative tasks.
SYSPROGRESS.SYSTABAUTH — This system table identifies users and the tables for which they have privileges. It also identifies the privileges the user has been granted, and the person who granted those privileges.